/*
 * The MIT License (MIT)
 *
 * Copyright (c) 2016 pjoc.pub, blademainer.
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 *
 */

package pub.pjoc.pay.dao;

import org.springframework.stereotype.Repository;
import org.springframework.util.Assert;
import pub.pjoc.pay.vo.ConfigInfo;

/**
 * Db service for config info.
 *
 * @author blademainer
 * @version 2016-10-20 22:14
 * @see ConfigInfo
 */
@Repository
public class ConfigDao extends BaseDao<ConfigInfo> {

  public ConfigInfo getConfig(ConfigInfo configInfo) {
    Assert.notNull(configInfo);
    Assert.hasText(configInfo.getConfigGroup());
    Assert.hasText(configInfo.getConfigName());

    //        ConfigInfo result = jdbcTemplate
    //                .queryForObject(
    //                        "select * from config_info where config_group=:configGroup and config_name=:configName",
    //                        new BeanPropertyRowMapper<ConfigInfo>(ConfigInfo.class),
    //                        configInfo.getConfigGroup(), configInfo.getConfigName());
    ConfigInfo result = queryForObject(
        "SELECT config_id, config_group, config_name, config_value FROM config_info WHERE config_group=:configGroup AND config_name=:configName",
        configInfo.getConfigGroup(), configInfo.getConfigName());
    return result;
  }

  public void setConfig(String configGroup, String configName, String configValue) {
    update("UPDATE config_info SET config_value=:configValue WHERE " +
        "config_group=:configGroup AND config_name=:configName ", configValue, configGroup, configName);
  }
}
